Usage Note 46243: Including the report name and filter information when exporting data from a graph or table from SAS® Web Report Studio to Microsoft Excel
By default, when exporting data from a table or graph, the exported content does not include the report name, applied filter information, the section name, or the object title.
However, if you are running version 4.31_M2, you can include the report name and filter information, as explained next. (There is no way to include the section name or object title.)
Include the report name
Make the following changes to the SAS Web Report Studio properties in SAS® Management Console in order to show the report name.
- On the Plug-ins tab, select Application Management ► Configuration Manager ► SAS Application Infrastructure.
- Right-click on Web Report Studio 4.3 and select Properties to open the Web Report Studio 4.3 Properties dialog box.
- Click the Advanced tab.
- Click Add to open the Define New Property dialog box.
- For the Property Name, enter
wrs.addReportNameToExport
- For the Property Value, enter
true
- Click OK twice to exit both dialog boxes and save the changes.
- Restart your web application server to enforce the new setting.
Note: When you export the entire report, the report name is not included in the output.
Include filter information
In order to include the filter information, in SAS Web Report Studio, open the report, select File ► Properties, click the Formats tab, and select the Display filter information option.
Operating System and Release Information
SAS System | SAS Web Report Studio | Microsoft Windows Server 2008 for x64 | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft® Windows® for x64 | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Windows Vista | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Windows Vista for x64 | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
64-bit Enabled AIX | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
64-bit Enabled Solaris | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
HP-UX IPF | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Linux for x64 | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
Solaris for x64 | 4.2 | 4.31_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2012-08-28 13:34:45 |
Date Created: | 2012-04-06 11:14:32 |